package com.ekingstar.framework.service;

import java.util.List;
import java.util.Map;

import com.ekingstar.framework.domain.PublicCode;

public interface CodeService {
	public String getCodeFromName(final String tableName,
			final String fromColumnName, final String toColumnName,
			final String value) throws CodeException;

	public String getCodeFromNameIfExist(final String tableName,
			final String fromColumnName, final String toColumnName,
			final String value) throws CodeException;
	
	public List<PublicCode> getPulbicList(final String tableName, String key,
			String value) throws CodeException;

	public List<PublicCode> getPulbicListForComboBox(final String tableName,
			String key, String value) throws CodeException;

	public List<PublicCode> getPulbicList(final String sql)
			throws CodeException;

	public List<PublicCode> getPulbicListForComboBox(final String sql)
			throws CodeException;

	public List<PublicCode> getPulbicListForComboBox(final String tableName,
			final String key, final String value, final String param)
			throws CodeException;
	public List<PublicCode> getPulbicListForMoreSelect(final String tableName,
			final String key, final String value, final String param)
			throws CodeException;
	public List<PublicCode> getPulbicList(final String tableName,
			final String key, final String value, final String param)
			throws CodeException;
	public Map getNameCodes(String table);
	public Map getCodeNames(final String table);
	public Map getCodeAndName(final String table,final String column1, final String column2); 
	public List<PublicCode> getUserType();
}
